
*************************************************************************************************************************************;
* Code Name: CreateCountryKey.sas
* Author: Per Siden, Sveriges Riksbank;
* Goal: Create a key from csv between country names (Swedish, English) and codes. 
*************************************************************************************************************************************;

proc import datafile="\\micro.intra\projekt\P0459$\P0459_gem\SAS DATA\Keys\Country_keys.csv" out=temp.country_key2 dbms=dlm replace;
     guessingrows = 208;
	 delimiter = ';';
     getnames=yes;
run;

data keys.country_key;
	length country_code_swe $ 2 country_code_eng $ 2 country_swe $ 40 country_eng $ 40;
	set temp.country_key2;	
run;

proc freq data = keys.country_key;
	tables country_code_eng;
run;

